﻿

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;


public class BLL_tbl_siconide_palla
{
    public BLL_tbl_siconide_palla()
    {

    }

    public List<tbl_siconide_palla> select(int ID)
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        return dal.select(ID);
    }

    public List<tbl_siconide_palla> selectAll()
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        return dal.selectAll();
    }

    public DataTable selectAllForGrid()
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        return dal.selectAllForGrid();
    }

    public bool insert(tbl_siconide_palla tbl)
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        int i = 0;
        i = dal.insert(
            tbl.Mill
, tbl.Feed_Rate
, tbl.RPM
, tbl.Room_Temperature
, tbl.Palla_humidity
, tbl.Remark
,tbl.Previous_Process
,tbl.CHARGE_Number
,tbl.FLOWBIN_Number
,tbl.MILLJET_RUN_NUMBER
,tbl.PALLA_RUN_NUMBER
, tbl.CREATED_BY
, tbl.CREATED_DATE
        );

        return Convert.ToBoolean(i);
    }


    public bool update(tbl_siconide_palla tbl)
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        int i = 0;
        i = dal.update(
            tbl.ID
, tbl.Mill
, tbl.Feed_Rate
, tbl.RPM
, tbl.Room_Temperature
, tbl.Palla_humidity
, tbl.Remark
, tbl.Previous_Process
, tbl.CHARGE_Number
, tbl.FLOWBIN_Number
, tbl.MILLJET_RUN_NUMBER
, tbl.PALLA_RUN_NUMBER
, tbl.UPDATED_BY
, tbl.UPDATED_DATE
            );

        return Convert.ToBoolean(i);
    }


    public bool delete(tbl_siconide_palla tbl)
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        int i = 0;
        i = dal.delete(
                tbl.ID
        );

        return Convert.ToBoolean(i);
    }

    public DataTable GetChargeNumber(string Previous_Process)
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        return dal.GetChargeNumber(Previous_Process);
    }

    public DataTable GetFlowbinNumber(string Previous_Process)
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        return dal.GetFlowbinNumber(Previous_Process);
    }

    public DataTable GetMillJet_Run_Number()
    {
        DAL_tbl_siconide_palla dal = new DAL_tbl_siconide_palla();
        return dal.GetMillJet_Run_Number();
    }
}

